begin tran

use DSRSystem

update Sectors set ShortName = 'Aerospace & Defense' where Number = '20101010'
update Sectors set ShortName = 'Auto Components' where Number = '25101010'
update Sectors set ShortName = 'Auto Components' where Number = '25101020'
update Sectors set ShortName = 'Automobiles' where Number = '25102010'
update Sectors set ShortName = 'Automobiles' where Number = '25102020'
update Sectors set ShortName = 'Banks' where Number = '40101010'
update Sectors set ShortName = 'Banks' where Number = '40101015'
update Sectors set ShortName = 'Banks' where Number = '40102010'
update Sectors set ShortName = 'Building Products' where Number = '20102010'
update Sectors set ShortName = 'Chemicals' where Number = '15101010'
update Sectors set ShortName = 'Chemicals' where Number = '15101020'
update Sectors set ShortName = 'Chemicals, Agricultural Chemicals' where Number = '15101030'
update Sectors set ShortName = 'Chemicals' where Number = '15101040'
update Sectors set ShortName = 'Chemicals' where Number = '15101050'
update Sectors set ShortName = 'Commercial Services, Printing' where Number = '20201010'
update Sectors set ShortName = 'Commercial Services, Diversified Services' where Number = '20201070'
update Sectors set ShortName = 'Commercial Services, Environmental & Facilities Services' where Number = '20201050'
update Sectors set ShortName = 'Commercial Services, Human Resources Services' where Number = '20202010'
update Sectors set ShortName = 'Commercial Services, Office Services' where Number = '20201060'
update Sectors set ShortName = 'Commercial Services, Research & Consulting' where Number = '20202020'
update Sectors set ShortName = 'Commercial Services, Security Services' where Number = '20201080'
update Sectors set ShortName = 'Construction & Engineering' where Number = '20103010'
update Sectors set ShortName = 'Construction Materials' where Number = '15102010'
update Sectors set ShortName = 'Consumer Durables' where Number = '25201010'
update Sectors set ShortName = 'Consumer Durables' where Number = '25201020'
update Sectors set ShortName = 'Consumer Durables' where Number = '25201040'
update Sectors set ShortName = 'Consumer Durables' where Number = '25201050'
update Sectors set ShortName = 'Consumer Durables' where Number = '25202010'
update Sectors set ShortName = 'Consumer Durables, Photographic Devices' where Number = '25202020'
update Sectors set ShortName = 'Consumer Services, Gaming Facilities' where Number = '25301010'
update Sectors set ShortName = 'Consumer Services, Education Services' where Number = '25302010'
update Sectors set ShortName = 'Consumer Services, Hotels & Cruiselines' where Number = '25301020'
update Sectors set ShortName = 'Consumer Services, Leisure Facilities' where Number = '25301030'
update Sectors set ShortName = 'Consumer Services, Restaurants' where Number = '25301040'
update Sectors set ShortName = 'Consumer Services, Specialized Services' where Number = '25302020'
update Sectors set ShortName = 'Containers & Packaging' where Number = '15103010'
update Sectors set ShortName = 'Containers & Packaging' where Number = '15103020'
update Sectors set ShortName = 'Diversified Financials' where Number = '40203010'
update Sectors set ShortName = 'Diversified Financials' where Number = '40202010'
update Sectors set ShortName = 'Diversified Financials' where Number = '40203030'
update Sectors set ShortName = 'Diversified Financials' where Number = '40203020'
update Sectors set ShortName = 'Diversified Financials' where Number = '40201030'
update Sectors set ShortName = 'Diversified Financials' where Number = '40201020'
update Sectors set ShortName = 'Diversified Financials' where Number = '40201040'
update Sectors set ShortName = 'Diversified Metals, Aluminum' where Number = '15104010'
update Sectors set ShortName = 'Diversified Metals, Metals & Mining' where Number = '15104020'
update Sectors set ShortName = 'Electrical Equipment' where Number = '20104010'
update Sectors set ShortName = 'Electrical Equipment' where Number = '20104020'
update Sectors set ShortName = 'Energy Services' where Number = '10101010'
update Sectors set ShortName = 'Energy Services' where Number = '10101020'
update Sectors set ShortName = 'Food Products, Agricultural Producers' where Number = '30202010'
update Sectors set ShortName = 'Food Products, Breweries' where Number = '30201010'
update Sectors set ShortName = 'Food Products, Distillers' where Number = '30201020'
update Sectors set ShortName = 'Food Products, Food & Meats' where Number = '30202030'
update Sectors set ShortName = 'Food Products, Beverages' where Number = '30201030'
update Sectors set ShortName = 'Food Products, Tobacco' where Number = '30203010'
update Sectors set ShortName = 'Food Retailers' where Number = '30101010'
update Sectors set ShortName = 'Food Retailers' where Number = '30101020'
update Sectors set ShortName = 'Food Retailers' where Number = '30101030'
update Sectors set ShortName = 'Food Retailers' where Number = '30101040'
update Sectors set ShortName = 'Healthcare, Distributors' where Number = '35102010'
update Sectors set ShortName = 'Healthcare, Equipment' where Number = '35101010'
update Sectors set ShortName = 'Healthcare, Facilities' where Number = '35102020'
update Sectors set ShortName = 'Healthcare, Services' where Number = '35102015'
update Sectors set ShortName = 'Healthcare, Supplies' where Number = '35101020'
update Sectors set ShortName = 'Healthcare, Technology' where Number = '35103010'
update Sectors set ShortName = 'Healthcare, Managed Care' where Number = '35102030'
update Sectors set ShortName = 'Homebuilders' where Number = '25201030'
update Sectors set ShortName = 'Household Products' where Number = '30301010'
update Sectors set ShortName = 'Household Products, Personal Products' where Number = '30302010'
update Sectors set ShortName = 'Industrial Conglomerates' where Number = '20105010'
update Sectors set ShortName = 'Insurance' where Number = '40301010'
update Sectors set ShortName = 'Insurance' where Number = '40301020'
update Sectors set ShortName = 'Insurance' where Number = '40301030'
update Sectors set ShortName = 'Insurance' where Number = '40301040'
update Sectors set ShortName = 'Insurance' where Number = '40301050'
update Sectors set ShortName = 'Machinery, Agriculture' where Number = '20106015'
update Sectors set ShortName = 'Machinery, Construction' where Number = '20106010'
update Sectors set ShortName = 'Machinery, Industrial' where Number = '20106020'
update Sectors set ShortName = 'Media, Advertisers' where Number = '25401010'
update Sectors set ShortName = 'Media, Broadcasters' where Number = '25401020'
update Sectors set ShortName = 'Media, Cable & Satellite' where Number = '25401025'
update Sectors set ShortName = 'Media, Film & Entertainment' where Number = '25401030'
update Sectors set ShortName = 'Media, Publishers' where Number = '25401040'
update Sectors set ShortName = 'Oil & Gas Producers' where Number = '10102050'
update Sectors set ShortName = 'Oil & Gas Producers' where Number = '10102010'
update Sectors set ShortName = 'Oil & Gas Producers' where Number = '10102020'
update Sectors set ShortName = 'Paper & Forestry' where Number = '15105010'
update Sectors set ShortName = 'Paper & Forestry' where Number = '15105020'
update Sectors set ShortName = 'Pharmaceuticals, Biotechnology' where Number = '35201010'
update Sectors set ShortName = 'Pharmaceuticals, Tools & Services' where Number = '35203010'
update Sectors set ShortName = 'Pharmaceuticals, Pharmaceuticals' where Number = '35202010'
update Sectors set ShortName = 'Precious Metals' where Number = '15104030'
update Sectors set ShortName = 'Precious Metals' where Number = '15104040'
update Sectors set ShortName = 'Precious Metals' where Number = '15104045'
update Sectors set ShortName = 'Real Estate, Diversified Activities' where Number = '40403010'
update Sectors set ShortName = 'Real Estate, REITs' where Number = '40402010'
update Sectors set ShortName = 'Real Estate, Health Care ' where Number = '40402045'
update Sectors set ShortName = 'Real Estate, Hotels & Resorts' where Number = '40402035'
update Sectors set ShortName = 'Real Estate, Industrial ' where Number = '40402020'
update Sectors set ShortName = 'Real Estate, Mortgages' where Number = '40402030'
update Sectors set ShortName = 'Real Estate, Offices' where Number = '40402040'
update Sectors set ShortName = 'Real Estate, Developers' where Number = '40403030'
update Sectors set ShortName = 'Real Estate, Operating Companies' where Number = '40403020'
update Sectors set ShortName = 'Real Estate, Services' where Number = '40403040'
update Sectors set ShortName = 'Real Estate, Residential' where Number = '40402050'
update Sectors set ShortName = 'Real Estate, Retail' where Number = '40402060'
update Sectors set ShortName = 'Real Estate, Specialized' where Number = '40402070'
update Sectors set ShortName = 'Refiners & Pipelines, Refining & Marketing' where Number = '10102030'
update Sectors set ShortName = 'Refiners & Pipelines, Storage & Transportation' where Number = '10102040'
update Sectors set ShortName = 'Retailing, Apparel' where Number = '25504010'
update Sectors set ShortName = 'Retailing, Automotive' where Number = '25504050'
update Sectors set ShortName = 'Retailing, Catalog Retail' where Number = '25502010'
update Sectors set ShortName = 'Retailing, Electronics' where Number = '25504020'
update Sectors set ShortName = 'Retailing, Department Stores' where Number = '25503010'
update Sectors set ShortName = 'Retailing, Distributors' where Number = '25501010'
update Sectors set ShortName = 'Retailing, General Merchandise' where Number = '25503020'
update Sectors set ShortName = 'Retailing, Home Improvement' where Number = '25504030'
update Sectors set ShortName = 'Retailing, Homefurnishing' where Number = '25504060'
update Sectors set ShortName = 'Retailing, Internet Retail' where Number = '25502020'
update Sectors set ShortName = 'Retailing, Specialty' where Number = '25504040'
update Sectors set ShortName = 'Semiconductors' where Number = '45301010'
update Sectors set ShortName = 'Semiconductors' where Number = '45301020'
update Sectors set ShortName = 'Software and Services' where Number = '45103010'
update Sectors set ShortName = 'Software and Services' where Number = '45102020'
update Sectors set ShortName = 'Software and Services' where Number = '45103030'
update Sectors set ShortName = 'Software and Services' where Number = '45101010'
update Sectors set ShortName = 'Software and Services' where Number = '45102010'
update Sectors set ShortName = 'Software and Services' where Number = '45103020'
update Sectors set ShortName = 'Steel' where Number = '15104050'
update Sectors set ShortName = 'Technology Hardware, Communications' where Number = '45201020'
update Sectors set ShortName = 'Technology Hardware, Hardware' where Number = '45202010'
update Sectors set ShortName = 'Technology Hardware, Computer & Peripherals' where Number = '45202020'
update Sectors set ShortName = 'Technology Hardware, Components' where Number = '45203015'
update Sectors set ShortName = 'Technology Hardware, Equipment & Instruments' where Number = '45203010'
update Sectors set ShortName = 'Technology Hardware, Manufacturing' where Number = '45203020'
update Sectors set ShortName = 'Technology Hardware, Office Equipment' where Number = '45204010'
update Sectors set ShortName = 'Technology Hardware, Distributors' where Number = '45203030'
update Sectors set ShortName = 'Technology Hardware, Storage & Peripherals' where Number = '45202030'
update Sectors set ShortName = 'Telecommunication Services' where Number = '50101010'
update Sectors set ShortName = 'Telecommunication Services' where Number = '50101020'
update Sectors set ShortName = 'Telecommunication Services' where Number = '50102010'
update Sectors set ShortName = 'Textiles & Apparel' where Number = '25203010'
update Sectors set ShortName = 'Textiles & Apparel' where Number = '25203020'
update Sectors set ShortName = 'Textiles & Apparel' where Number = '25203030'
update Sectors set ShortName = 'Traders & Distributors' where Number = '20107010'
update Sectors set ShortName = 'Transportation, Air Freight' where Number = '20301010'
update Sectors set ShortName = 'Transportation, Airlines' where Number = '20302010'
update Sectors set ShortName = 'Transportation, Marine ' where Number = '20303010'
update Sectors set ShortName = 'Transportation, Railways' where Number = '20304010'
update Sectors set ShortName = 'Transportation, Trucking' where Number = '20304020'
update Sectors set ShortName = 'Transportation Infrastructure' where Number = '20305010'
update Sectors set ShortName = 'Transportation Infrastructure' where Number = '20305020'
update Sectors set ShortName = 'Transportation Infrastructure' where Number = '20305030'
update Sectors set ShortName = 'Utilities, Electric' where Number = '55101010'
update Sectors set ShortName = 'Utilities, Gas' where Number = '55102010'
update Sectors set ShortName = 'Utilities, Independent Producers & Traders' where Number = '55105010'
update Sectors set ShortName = 'Utilities, Multi-Utilities' where Number = '55103010'
update Sectors set ShortName = 'Utilities, Renewable' where Number = '55105020'
update Sectors set ShortName = 'Utilities, Water' where Number = '55104010'

commit